package com.mayuhao.classmanage.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.mayuhao.classmanage.entity.CssClass;
import com.mayuhao.classmanage.entity.CssClassVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author 马宇豪
 * @since 2022-10-25
 */
@Mapper
public interface CssClassMapper extends BaseMapper<CssClass> {

    /**
     * @return com.baomidou.mybatisplus.extension.plugins.pagination.Page<com.mayuhao.classmanage.entity.CssClassVO>
     * @description 请修改方法描述
     * @methodName page
     * @params [cssClassVOPage, searchId, searchName]
     * @paramType [com.baomidou.mybatisplus.extension.plugins.pagination.Page<com.mayuhao.classmanage.entity.CssClassVO>, java.lang.String, java.lang.String]
     * @author 马宇豪
     * @date 2022/10/25 0025 下午 5:33
     * @email 1757442521@qq.com
     **/
    Page<CssClassVO> page(Page<CssClassVO> cssClassVOPage, @Param("searchId") String searchId, @Param("searchName") String searchName);

    @Select("SELECT css_profession.profession_id,css_profession.profession_name FROM css_profession")
    List<CssClassVO> findPro();
}
